-- @author lixiyong01
-- @date 20240709
-- ods层host_zzdetail数据处理
-- 日志在消费或者上传的时候会有重复需要针对主机+采集时间点进行去重

use hdp_lbg_supin_zplisting;

insert overwrite table ods_hism_host_zzdetail partition (dt='${RUNDATE}')
select
    items[0] as movie_id,
    items[1] as imdb_id,
    items[2] as tmdb_id
from (
    select split(content,',') as items
    from hdp_lbg_supin_zplisting.raw_hism_host_zzdetail
    where dt = '${RUNDATE}'
) t;
